class CreateFlickrDatas < ActiveRecord::Migration
  def self.up
    create_table :flickr_datas do |t|
      t.column :crawl_id, :integer
      t.column :full_name, :string
      t.column :gender, :string
      t.column :rel_status, :string
      t.column :joined, :datetime
      t.column :hometown, :string 
      t.column :hometown_country, :string #ISO Country Code notaion
      t.column :locality, :string
      t.column :country, :string
      t.column :occupation, :string
      
      t.column :last_update, :datetime
      # t.timestamps
    end
    add_index :flickr_datas, :crawl_id
  end
  
  def self.down
    remove_index :flickr_datas, :crawl_id
    drop_table :flickr_datas
  end
end
